package pro.spring.inter;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import pro.spring.model.Information;

public interface InformationMapper {
    int deleteByPrimaryKey(Integer inId);

    int insert(Information record);

    int insertSelective(Information record);

    Information selectByPrimaryKey(Integer inId);

    int updateByPrimaryKeySelective(Information record);

    int updateByPrimaryKeyWithBLOBs(Information record);

    int updateByPrimaryKey(Information record);
    
    int selectByPrimaryKeytwo(Integer inId);
    
    Integer selectCountByKey(String key);
    //得到总条数
    Integer selectCount();
    
    //分页查询
    List<Information> selectListPage(@Param("offset")Integer offset,@Param("pagesize")Integer pagesize);
    
    //按照文件类别查询
    List<Information> selectListPageByType(@Param("inType")Integer type,@Param("offset")Integer offset,@Param("pagesize")Integer pagesize);
    
    //按照文件类别总数
    Integer getCountByType(@Param("inType")Integer type);
    
    //按照视频id查询
    Information selectByVedioId(String inLocalhost);
    
    //按照分类得到最大id
    Integer selectMaxIdByType(@Param("inType")Integer type);

  //按照分类得到最小id
    Integer selectMinIdByType(@Param("inType")Integer type);

    List<Information> selectListPageByKey(@Param("key")String key,@Param("offset")Integer offset,@Param("pagesize")Integer pagesize);
    
    List<Information> selectArtListPageByType(@Param("inType")Integer type,@Param("offset")Integer offset,@Param("pagesize")Integer pagesize);
}